Query not working after deleting field in table due to field used in query.
Cause:
The underlying table no longer contains the field used in the query to return results.
Solution:
In the Query Design view, remove the field name which no longer appears in the underlying table.
1) If the Database window is not active, activate the Database window.
2) Click the 'Queries' tab in the Database window.
Queries tab
3) Select the desired query in the list box. (The selected query is highlighted.)
4) Click 'Design'. (The query appears in Design view.)
5) Position the mouse pointer above the field name in the 'Field' row to be moved. (The cursor changes to a black down arrow.)
6) Click mouse button. (The selected column is highlighted.)
7) Select the 'Edit' menu and select 'Delete Column' to remove the field from the query.
8) Select the 'File' menu and select 'Save' to save changes to the query.
